SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586829 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586829 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653275,355336,861250,1033084,319140,656314,214164,226211,228188,942156,528024,355225,60627,469537,53395,481086,97937,11498,112354,408089,456010,148071,201040,140086,591102,788423,766823,13170,202724,201516,658237,84796,100135,1026596,581576,54058,874432,626574,125598,991939,607959,191568,1025202,237960,87387,99834,32922,84098,770045,20681,770007,469919,187636,890579,479412,597076,471402,575496,870324,853869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]