SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501246 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501246 [ RunTime:0.003965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134546,309071,97680,8111,511689,961461,398940,170253,332877,991990,900821,655098,493268,853528,994588,301987,983096,8183,335418,1008295,214184,97275,77425,576996,322753,554493,22884,209476,48205,260985,1006902,508235,893211,794270,602560,652572,727257,882623,546099,454587,1005201,542023,426629,53235,902295,615192,474306,880911,399123,730887,769805,872698,300528,123482,957036,773877,955385,508626,91704,128260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]