SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522822 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522822 [ RunTime:0.001290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63520,969175,417249,337822,279739,127650,168852,1043846,935709,1046291,1019655,543643,672431,782290,717528,198888,766854,289988,259612,334294,395671,33240,537960,346064,127063,830284,521961,504903,1001392,1019950,959422,497167,440471,878111,169294,754365,1009737,562241,890262,639453,439812,662447,515687,621722,968872,926343,897210,1014345,995950,425365,500183,851621,277256,413670,98959,939411,462271,418910,747412,820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]