SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413117 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413117 [ RunTime:0.002921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115192,541862,121356,854193,441813,540650,895707,394645,612503,616428,920559,231004,1035609,385732,163267,266904,856687,28045,978387,717994,1008556,818960,751050,741595,492044,706935,810875,1023464,778921,568222,12435,995359,424132,674649,759145,558233,60489,61711,123559,850699,900362,413373,911069,601391,995677,941135,51832,76256,5329,137073,300459,431558,858767,133263,245837,45234,940128,378441,962546,482163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]