SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522975 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522975 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65012,327807,877927,185436,282323,672683,762569,629549,158003,928936,597750,145543,64360,117107,471750,941035,491694,196698,696696,781106,1028913,866280,531010,182306,37192,286486,149905,599550,421490,1027569,107604,200230,209298,580483,407000,333506,618989,1011904,208162,997294,984321,163969,492736,580104,1019321,67442,430097,135762,593247,445210,829811,962842,620599,1046312,728691,573932,1022701,494124,6976,634737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]