SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142586 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142586 [ RunTime:0.003523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270008,73862,587401,425379,44710,71020,271497,1032596,43,305062,98587,859179,459984,990277,269265,288482,1046622,743153,446810,988257,985752,930096,677566,715348,914728,544943,636365,617145,589834,974872,787234,618045,624117,572774,566465,158045,368159,872787,540111,286587,724568,680426,28708,914101,397278,548663,798413,1022186,998554,419976,616210,41708,993712,551633,372639,836374,966176,543521,711558,99003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001651s ]