SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012811 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012811 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79225,502110,411324,490485,801572,842901,486909,405898,270009,64568,450527,622292,143846,865090,307360,507142,323116,546385,367583,947951,207677,123742,219678,928050,775577,743157,691024,705865,147924,872781,394871,853572,631376,302568,874400,1008189,482662,289449,166869,922904,982983,412783,8503,962408,694669,554190,607766,93810,789996,29710,360743,561961,30238,756156,939975,123181,399704,865146,341392,686189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]