SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468030 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468030 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123244,1032612,75303,936083,463896,619601,694197,328753,715034,173545,880707,815035,838117,203437,114570,647652,925217,833670,967023,847782,498001,23489,124172,632369,853050,526907,357610,689767,1047352,966826,370424,683194,960155,3850,823550,534605,265419,396085,66991,271053,888234,544051,184839,1016724,213423,827654,534364,445098,890434,835816,7192,868823,665857,870774,775485,553707,415164,497303,113170,596327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]