SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534883 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534883 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45840,469741,1046592,232058,730512,195984,728604,569922,382723,48635,23000,805278,329639,954697,1012418,551310,93081,1032076,1017037,793716,670734,704601,384765,360126,676227,807137,873795,768861,606967,270250,84513,762284,701313,187808,640398,288646,587263,812141,191093,100625,14197,888251,199659,600222,45409,247700,726360,317663,889968,30437,217816,29915,740021,908024,595573,937077,524283,877505,260066,893132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]