SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43842 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43842 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886960,928261,282568,751324,777952,762340,447881,814608,621627,721400,70958,347325,481833,833795,1012623,654673,1037137,294010,115080,71012,824315,534025,282250,357163,191788,959411,991653,884171,556783,988528,928342,144438,945528,661544,851237,118169,693065,778682,378441,189196,1010854,725653,351068,710755,885224,253945,247104,1007250,330886,619570,865841,337751,975847,282482,183844,198473,567518,452375,649688,494389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]