SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012470 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012470 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379924,826108,54277,296757,990863,657377,17449,891854,356400,737077,495589,877812,1043820,25999,477984,782300,494617,190216,246508,206720,725547,302486,892728,326320,914092,283224,549311,75979,752888,1010215,46668,798622,381364,960723,104287,435909,469085,369633,350094,123263,628928,386802,549252,586762,919947,505381,4877,680461,268584,575821,689405,674207,964821,37228,803033,861892,648049,1024088,552797,648066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]