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` = 439261 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439261 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376681,452760,564820,839273,97841,209877,264989,672424,867291,312292,269225,843040,237482,44197,792330,968356,165296,536160,589807,713714,741171,615584,329626,184654,690390,47779,809533,558229,442271,65576,364115,826217,351841,1024843,27503,158833,595702,233012,440488,837296,488718,810314,416872,613067,984023,669203,341829,806129,231341,540116,114907,845386,171981,531066,773620,700163,1016639,248138,21786,996967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439261 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439261 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]