SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401033 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401033 [ RunTime:0.001503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174234,56432,192186,498454,261935,919342,704701,134305,216512,965131,799483,917404,549040,142594,223338,893423,58011,718708,549012,311176,876515,567285,566645,991627,388933,366638,204617,972692,916444,669256,565186,827524,457930,456503,199364,918911,1007655,745721,870730,15171,790209,615762,813609,883040,930595,530386,447034,111171,1045541,72083,185705,174032,217046,1029634,1018452,787384,450477,508161,541050,251375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]