SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417655 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417655 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688856,508932,608169,825773,749633,1010834,569944,475115,905639,637844,854304,485247,229390,146744,737218,759169,119083,170597,267717,492955,697495,1031190,184142,779340,524849,152777,275591,1000583,664136,501032,302876,449534,36429,492820,542927,604352,1029077,563530,1002473,76515,68287,4218,178112,446168,598397,15122,581705,167148,482711,244999,1026021,97962,621006,135971,552061,690297,20063,140651,481491,508940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]