SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34474 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34474 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317849,373994,594401,354479,275044,606693,577840,528841,60589,482059,400096,313838,5867,945260,619855,1024880,861852,802084,278715,777428,268675,341881,570429,1010400,915462,383009,296953,378700,322865,437767,976062,519694,826794,524281,830646,137316,344345,701574,377084,813003,397154,335993,108761,919941,476925,667545,654617,711858,748565,688433,597031,328400,257275,958953,1042414,748963,361906,270475,552264,209812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001563s ]