SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022648 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022648 [ RunTime:0.002046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780322,559175,584578,890416,439951,526443,304321,41620,549966,596066,165447,222540,702750,352465,636632,556154,771503,223629,755218,829926,749480,895219,508931,794635,514660,237956,312928,909803,999264,862512,654922,363228,946228,209563,301566,901563,430314,465588,1045389,778551,52600,218554,751693,702294,667758,957635,217578,573811,503105,452185,48376,48222,244145,93911,404447,458911,574571,918986,273603,346109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]