SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547841 LIMIT 1 [ RunTime:0.000932s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547841 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280285,640027,865727,799617,533601,199453,145641,965449,94948,877336,1014451,477958,870744,458221,160320,185626,91801,571917,949593,581629,1027981,514348,268710,418598,415128,391273,592304,147843,11861,728143,273079,715274,1029050,588884,1034833,821837,588204,469255,983138,544252,130241,205737,499124,379378,331828,1029737,629268,241021,201188,1045440,842593,478358,396347,323962,208564,362668,756549,303051,582325,454001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]