SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501608 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501608 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312380,212789,654685,573290,731937,369650,781787,717800,228181,77578,144029,564876,416287,214595,572037,330369,229251,227631,602007,912743,357464,605159,865187,48806,249094,846567,677227,69217,318325,541854,320601,743429,228703,317850,648825,1011475,836011,391794,595942,923700,13010,868306,28467,690794,604489,596973,755766,1023632,937042,569290,26792,143636,613178,322668,271610,605297,122669,415450,415810,733817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]