SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008460 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008460 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498922,962073,897086,225875,451476,233470,478719,634072,731149,632272,392001,159348,284956,507103,56106,721125,1034277,616083,266740,1019129,6044,854907,104746,438442,919630,390190,203351,924770,860552,291267,331138,757352,432506,981140,121185,820787,852288,793455,138873,636342,80781,104702,344628,809639,958742,83078,323093,205216,942185,959454,436626,363616,206061,1005905,724295,800738,447484,308389,589627,642242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]