SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403999 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403999 [ RunTime:0.003047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419145,387185,539717,540916,54590,511122,104248,687458,378880,957058,460622,1034600,113100,1036701,882417,782074,442878,323249,663809,685964,394786,806406,202884,966390,40326,429097,631998,769433,292837,9594,557441,30526,268529,436665,223287,794911,265964,278145,251056,769263,891957,198334,258674,866878,1018604,700424,213727,137833,156155,540062,251596,829275,894831,556437,908387,435261,220444,492455,662558,349939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]