SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683671 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683671 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347506,401818,721128,687056,40900,102030,278951,865871,715819,507918,946412,958044,830810,326120,843249,305209,744623,451512,104742,81,455791,661930,1028988,512980,576866,952786,562043,404604,83936,1041384,802928,17235,1000500,671843,618835,718326,779853,753659,823774,1025194,1038761,800283,537046,100164,129891,962064,301778,189799,106370,725471,447427,642599,382110,291632,741532,266194,544740,1039266,939874,455180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003916s ]