SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400551 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400551 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733464,515651,987815,373035,560171,714525,17501,669675,609910,604961,291684,97117,310248,540443,608901,1044783,144560,687958,551626,390026,399969,828916,607492,518400,156194,1048212,1029271,671882,673735,620108,828195,882538,443113,591222,626142,810588,442029,584281,908155,803942,641337,13916,56187,1018305,1905,256702,117140,211475,505621,124813,988480,990089,581904,596168,914651,328747,56194,639961,482653,355003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]