SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003796s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305898 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305898 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493221,482988,688899,1030020,503696,289043,605942,689310,637030,793144,924778,832643,73053,1018065,236852,253730,905731,700026,191431,498853,973254,91897,346173,219454,289971,1026373,961954,438753,281934,965544,928980,795379,197256,268428,699805,645077,513774,817128,852635,81918,520158,1031041,736969,236841,993620,382469,529227,570982,411641,64140,972044,567489,282116,282689,597207,791024,609835,14754,1048797,567695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]