SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353846 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353846 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470930,971410,393115,216273,532644,454582,1006312,692319,230294,605161,29533,992427,696871,737246,710009,210300,194375,982611,511153,228975,633587,662439,757744,22078,354053,415121,882269,529007,546133,1046056,991554,610520,96703,529110,551996,46222,483066,645534,157744,884511,312085,393338,145725,977574,640790,35223,14191,156337,531416,963404,869282,570495,598583,145914,955996,586828,331491,336989,422545,12982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]