SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154698 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154698 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636809,167920,74687,476838,431400,445175,331907,693756,575346,456403,752131,575842,417450,1021869,277121,191257,10782,45997,724694,83270,878141,391495,21010,580670,399931,694989,854438,687089,575035,835934,553394,994877,148361,604181,228249,1020725,789281,73882,552049,618531,462330,739166,614380,770919,129168,534195,571502,484631,143762,183437,340303,390760,918097,827952,971209,147893,112918,567136,629522,780105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]