SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001989s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291710 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291710 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731839,514284,191179,95645,443627,568223,524768,310299,61714,443261,254107,865936,329174,175643,567534,803784,422208,495483,140540,961011,591036,192222,466753,236212,374083,921557,957179,707930,300031,981373,761374,992541,638530,559641,608833,689800,44404,774882,421816,866530,350454,62659,1021652,162933,301406,360026,758704,598540,369249,662815,118089,814863,46911,794998,230925,738502,693095,108061,347915,191207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001648s ]