SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148445 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148445 [ RunTime:0.001875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000091,974259,972484,871442,611073,102151,83204,239782,148763,507243,3981,1022228,100114,441235,372532,732240,151006,621946,293077,136446,676948,362341,600678,915036,29444,384565,151613,890186,3763,772104,578393,1003440,976152,446541,1016131,952237,830664,935471,972334,876756,72039,406729,324451,537070,755561,706065,580961,215644,182156,19316,711244,978270,957843,939294,460741,971599,740473,456968,850048,453381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]