SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004492 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004492 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282286,50576,807068,375764,786839,204034,138885,332845,386418,367281,242298,735562,708078,692862,661304,213340,148829,220445,33248,42019,426067,118365,162274,103568,949740,464202,109648,537329,229229,8651,750595,53624,666726,792382,733275,608208,645284,534810,612460,906168,70101,773131,1020030,726899,987720,172832,548681,981811,267394,457595,136500,434905,767524,751427,403129,722398,694098,561146,274549,857699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001867s ]