SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806970 LIMIT 1 [ RunTime:0.003317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806970 [ RunTime:0.003901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989285,923220,242462,416648,249272,117034,211455,845712,814203,538468,71196,1011642,989776,123430,666937,550938,14000,788421,901613,808057,83262,908628,780246,174754,168200,113450,1028179,378670,818484,1025283,68358,92547,213517,814914,733522,295617,90055,1027081,784274,91397,676142,34834,456145,416295,304182,129129,915670,230842,939824,705378,862946,599524,254700,288587,266129,130612,1006869,703448,48524,235238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]