SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336800 LIMIT 1 [ RunTime:0.000862s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336800 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675534,1033218,598914,784362,32431,44954,652489,567956,51509,460639,198832,242015,709007,36545,16659,297178,43053,38370,1047632,550225,223965,169079,397515,1005335,998238,519899,63649,416578,92132,344292,915062,158908,569134,157603,257715,257387,476739,699354,31813,79427,1007988,359888,822300,278767,953200,279220,120906,1034850,896595,1022948,379200,752180,818415,328891,713201,498260,64889,787394,439756,256711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.022399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002445s ]