SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036648 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036648 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642353,38990,689803,119866,938957,271890,229873,755558,23491,285782,179318,694432,505830,211420,946002,38556,215463,352618,156575,270333,907301,917579,1028192,701442,680841,831944,450749,253706,991259,480481,350491,621831,302399,741367,738463,176928,421918,109820,150024,167631,168260,345118,773073,525482,417075,837915,228899,817231,374953,360128,855861,811182,334077,350290,547477,622426,269992,33579,684730,360903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]