SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49083 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49083 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519797,384875,332459,749159,251218,818148,292419,707602,575598,597800,265770,968858,838937,813536,486589,175763,699260,29024,691822,188298,600243,346811,881947,948433,541200,636302,977841,691682,787151,236653,763554,782370,369657,562462,804866,35985,853571,1027988,509518,9043,434938,196152,318436,682282,386284,88903,408228,354712,84281,389242,580454,29464,194809,450378,140840,902537,612974,779470,104235,139773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]