SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43638 LIMIT 1 [ RunTime:0.001512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43638 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345820,52040,341349,994801,695338,266415,294376,533877,289018,96798,731277,990297,742661,97557,792904,746905,1037885,190965,946406,280517,838368,653046,625703,443200,457167,1007681,585887,53549,921625,413555,291701,6173,832932,933122,527072,283572,710757,841074,731595,242312,1013046,183217,805974,301165,506706,2413,657101,146386,245763,531745,897585,201401,370353,565743,40287,505429,81377,786978,576538,170376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]