SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453561 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453561 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612365,644527,1008343,657509,544482,1016508,36867,2078,1027910,626814,755750,38257,495311,830917,96663,759853,764109,863366,127583,384287,1044179,831822,418830,612656,1017649,827502,1009350,469394,473114,851467,811581,435166,425084,545832,476561,546125,24194,451783,1018213,676908,803841,865983,952270,570324,36417,1023099,80365,246953,267741,207710,535652,526285,671190,448891,332279,826531,281995,281503,662264,797506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]