SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545071 LIMIT 1 [ RunTime:0.001111s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545071 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744648,676182,908718,545490,625818,557637,592879,736775,852335,69604,606902,931865,20884,86180,930890,858574,327576,286687,532387,63333,373068,578594,57787,523849,92511,243413,154227,736302,792752,311204,566129,851430,243590,121567,155722,211070,699322,574052,753157,672826,726234,879756,242661,616646,151381,601090,413605,160398,123041,875442,765773,926754,881720,279418,125185,834389,936292,611407,962915,406915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]