SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512384 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512384 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401113,242919,397944,945479,373418,408952,357178,1029962,747626,203387,63091,56625,650081,993073,506725,45003,807221,778449,438778,293397,458051,856455,812267,235611,298925,944323,832012,170532,37237,1046356,39028,939762,553801,459432,165775,59804,378852,578746,38913,464755,171889,180837,59380,437772,672170,622321,897508,123098,684626,26161,721830,761761,417705,79986,625989,464041,213541,756557,996268,670834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]