SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329630 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329630 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119196,899501,829361,771102,981778,568092,657237,875102,552242,890199,585507,401336,964230,685706,292016,791531,474388,1014862,275711,432785,431863,316812,480719,766189,137838,333928,911400,820183,31852,695248,974360,349065,1019023,807414,1017498,662379,125607,782731,280449,514226,864504,502530,884371,180795,103173,379430,379783,451678,49559,110898,716266,509091,790035,17132,714033,786295,565056,1010191,529700,130490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]