SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801512 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801512 [ RunTime:0.003134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330918,736484,209174,526955,598370,489865,123108,514443,783306,887425,414183,107030,986472,954091,780457,478572,742814,899408,121138,634994,435188,392747,822081,94246,787680,58878,713133,114860,762581,168970,393319,32097,738884,968269,110036,424989,809421,504193,204216,805271,204681,615186,162935,417875,346730,108819,78659,309353,214513,635905,802956,63447,687781,73596,101166,959423,750563,47742,923948,836012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]