SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190801 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190801 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279229,1015670,910640,577082,1012934,1036458,733036,447364,737221,432146,588868,709856,352001,208543,934254,984672,225848,214279,367023,568154,1043457,983729,507325,807534,898437,854546,924097,724918,698866,526908,52146,486777,630205,939304,2780,701579,839844,137641,882806,524642,745902,315455,658747,1025838,876710,902022,548188,628568,468132,890871,404574,692914,688042,46317,104752,444309,76338,866754,556320,452471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]