SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021553 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021553 [ RunTime:0.009962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629922,228742,613188,383655,965405,408956,791828,114340,677204,721602,262772,646056,676115,284508,550029,595091,212577,818867,907811,761462,296173,206619,959755,251138,248288,348419,563159,133343,77131,1048033,190753,337883,707077,620188,723390,407199,88319,665056,685188,130650,1025821,560335,751670,64855,275278,532995,697465,301296,520766,490424,36619,300223,706235,1009995,595294,1031319,470808,192542,785872,763380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001456s ]