SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53770 LIMIT 1 [ RunTime:0.002241s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53770 [ RunTime:0.008304s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511408,92313,457719,298700,879869,434010,1038106,127498,850769,1042828,231644,857386,227305,864121,815339,58131,728125,958975,1010098,886251,32020,989237,502079,547001,510112,85789,497379,751672,139576,232070,810202,412704,601802,241162,675665,491802,445234,704387,706282,1042122,449059,586329,325176,474961,146614,35089,505815,706501,260763,686562,468839,592882,121485,453242,485562,198141,56000,965734,728927,177410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]