SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209682 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209682 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248171,698804,246282,768318,578837,607538,749972,964561,968186,529458,645004,40146,501164,404088,270113,391976,612207,20455,167229,898413,450137,659697,574037,487991,673287,261739,434801,649477,201804,400656,293625,1008848,425797,7035,697461,1026336,603316,952719,1046020,215870,959436,749453,471962,151812,975915,714739,166890,368504,316257,393266,315871,464670,819545,1038596,298001,252030,338047,1016183,526898,4345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]