SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429825 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429825 [ RunTime:0.002469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141494,54250,66192,402895,221486,834116,60088,186655,537394,778046,932423,725846,1022167,885944,394332,332935,31003,834657,482697,1937,991840,594065,166520,959961,429439,847350,652037,629760,23757,841381,195231,881081,625106,664575,411141,623246,114973,91582,2710,767053,484758,213615,261630,433746,596300,1043014,593513,941892,976750,842405,705112,987533,815725,136242,750258,97111,448692,537768,270185,652759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]