SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001445s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107616 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107616 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918144,956899,419622,470369,352151,895102,386508,565519,811127,245000,783081,473607,271086,958668,826580,762191,666853,1029764,453506,257140,879845,290253,776187,417126,9745,691451,612084,1032168,384936,635356,529933,965218,274867,10882,90687,825878,573601,240973,690818,826880,503801,142724,65,744082,897333,924572,569280,98949,346068,238014,1023785,297121,1035126,949692,159834,871325,682690,700857,743795,12875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]