SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335694 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335694 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701403,447544,99200,504742,367696,294017,901574,1035330,141903,562851,402582,770857,651201,621917,735289,384859,88548,567823,503574,707594,361671,997982,179993,684308,735076,746109,916584,476477,651496,423972,182297,445022,189060,129919,528499,893976,752010,164440,868341,103776,248663,147752,983558,336771,373956,953458,662828,664181,212927,992972,699096,481482,767276,760734,657343,762812,883089,183858,801874,701296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]