SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201192 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201192 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420853,740143,577989,718153,670220,992084,714486,137912,866584,105106,31480,519609,51890,967558,215950,444719,892532,774672,375308,446310,261995,113869,724267,791646,901859,74798,647090,104999,865481,540566,503628,457256,100162,286282,304789,358098,987987,510339,806399,611161,226652,69652,581678,764846,858765,916961,349295,885709,320953,13345,826986,559499,540344,392761,87246,708240,915980,863607,282603,529291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]