SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514997 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514997 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174648,581328,705769,993629,157583,852680,860763,209966,804875,441954,847356,572620,222435,130031,373161,1034389,499051,796579,848258,132745,487113,303781,925450,1934,143721,239669,446563,186969,480296,542002,319243,257192,772774,184368,500379,503008,896987,66599,211263,262756,403786,34384,388091,133840,806268,665848,961167,910856,483382,781681,768400,406999,189234,106074,487894,545905,463743,84382,959,704585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002294s ]