SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 174080 LIMIT 1 [ RunTime:0.002104s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 174080 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913005,207003,225265,437970,162603,491345,760308,618318,312646,189789,638049,301737,809518,41244,1028710,174809,156407,140055,291698,426930,832309,78150,45530,155088,99454,991915,874000,886630,653687,848312,975880,281494,298434,424039,384781,1000632,910130,807857,76121,951746,546301,1001781,888990,437345,468012,983901,307274,108495,787403,360901,921344,745736,228247,131747,898693,568139,909231,353635,506488,736252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 174080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 174080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]