SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547815 LIMIT 1 [ RunTime:0.000999s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547815 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23797,1034494,861853,174289,756335,295426,792659,49732,319868,685622,110257,115922,663978,606155,1037358,881122,466553,987168,803073,749267,567471,588878,109407,990418,474520,295009,392413,735067,931140,1043412,424181,908567,658990,996654,314239,250174,145441,586087,170587,592843,306843,620005,569965,998198,875410,355478,395579,470321,648684,199724,541699,1020127,845591,160289,291954,461695,114642,315139,481945,240629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001679s ]