SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 712803 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 712803 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007743,163111,375676,471192,876366,740656,757189,657202,775639,870870,327181,433069,466327,525512,96331,385015,88189,1022770,874330,565025,73361,621366,888458,637885,81318,130942,374340,777897,558752,60161,63291,418274,65017,309664,766077,12572,652152,86355,119452,983166,891971,1047557,706815,511390,953220,995386,948496,171404,682503,573330,26554,154928,287853,471741,809340,558467,843399,290255,332704,857843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 712803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 712803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]