SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451886 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451886 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006157,412938,369898,127343,243702,847681,775667,645475,594529,606378,434351,1008602,715005,23280,322971,699143,602643,527602,869494,1041940,419331,152056,347375,498874,294658,39757,8366,402003,496749,544945,930415,379494,705341,557596,425668,197119,790655,347089,537175,580943,81180,84290,1006104,194202,384993,480820,200018,526034,696791,968461,69285,815731,1039485,898740,1034203,735218,93043,298018,856586,695497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]