SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575763 LIMIT 1 [ RunTime:0.003429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575763 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632380,552291,219574,503102,805648,673040,1046552,461491,28253,364208,529388,713747,528897,190666,616776,218441,207287,1010624,965472,453133,61486,676717,626885,34189,997547,541774,959967,272113,529133,578851,770063,851598,253819,1001697,711536,438709,961816,662110,137415,136830,741464,388424,143465,339420,777753,235960,154654,480306,612711,677992,597063,143441,344484,119058,146240,62692,81365,306463,734641,842427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]