SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805671 LIMIT 1 [ RunTime:0.001651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805671 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121612,384230,654346,32895,379362,26006,928163,542671,516175,240050,963197,883109,311164,212986,464148,346357,557362,141512,360818,772501,902869,997532,457128,362036,752343,329380,852528,912079,508302,421173,493378,830678,402821,456781,279742,530831,365973,505359,36160,707519,580367,880166,371465,985532,108546,107599,416491,555771,570089,906046,915105,161569,360025,960054,289164,962742,466591,990107,301477,837016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003583s ]