SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 30680 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 30680 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793597,412030,383824,720389,736365,407953,898287,1037171,1013905,250042,835626,263572,914444,11305,788189,645194,156525,423768,902557,570174,485936,969760,60518,706970,49372,48552,772892,113631,989480,960118,372470,707776,671168,75504,845149,411806,648270,177621,277934,545398,14943,615423,351103,108687,860943,139998,967049,88809,709169,532581,1167,50283,999645,144451,993636,1009576,642420,106178,5882,631321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 30680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 30680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]