SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682003 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682003 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957065,253973,992075,826431,907480,263524,25182,563530,99175,268216,158808,163988,169481,177383,231189,545831,756110,127488,1037535,355350,35958,102829,918386,742182,865820,321225,648911,760947,868566,993800,477397,492241,381311,598029,421640,131104,222123,988135,30652,830238,557600,239441,405023,381610,404481,422249,249626,924312,652699,697854,908719,726979,48906,18709,502081,593804,483984,943488,472144,364182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]