SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537294 LIMIT 1 [ RunTime:0.001043s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537294 [ RunTime:0.004435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570968,845018,30424,271934,614428,882805,719628,997076,432825,389427,888871,5649,895925,39840,508123,602058,738096,585366,515995,158400,803317,105226,204477,989823,896046,265472,896886,774383,1015085,675664,382068,978822,927080,63729,1022169,981424,972715,676618,408689,494153,485907,168683,607487,288311,213856,238763,503630,32992,151918,673720,628372,501871,89684,590390,199786,196480,49945,80162,728375,373880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]