SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517743 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517743 [ RunTime:0.001445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562263,136614,858365,69279,786966,399579,47680,162138,332794,1006119,26563,755145,615046,510703,378389,911086,576148,594673,551053,474502,916740,708465,914288,543336,180689,599014,197470,806867,841169,617435,647278,101537,424348,715190,72655,908015,723566,630505,358272,704595,684096,29121,893014,70001,54454,280191,601910,99204,42652,497013,635797,545720,583068,743724,938931,545080,395397,1045937,173828,239467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]