SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469065 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469065 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73829,395048,355094,1020321,759088,554835,988526,150913,881993,856884,620605,123022,734648,337340,835435,581478,105429,600954,118691,555384,1023267,1036416,606946,4526,799740,8902,896470,611220,560882,181272,551350,581961,227538,695212,1041991,660049,774288,791405,69133,827352,157849,1010096,893297,115274,50275,175041,902698,605251,926166,613937,605561,386153,764856,17419,59901,815198,33419,977604,677609,98630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469065 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469065 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]