SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021680 LIMIT 1 [ RunTime:0.000759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021680 [ RunTime:0.006746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762144,440479,273498,585958,823842,867289,107879,196279,836529,276004,943897,462081,717735,862506,1030456,1031896,679087,585813,64160,943567,84322,310180,660687,777173,5858,930642,581614,661707,72169,554861,918389,26440,979128,207992,660806,327024,216568,193876,647089,106985,704162,835309,273491,656101,37435,366837,14508,1020900,578166,313760,538364,831926,595498,456943,285410,814551,428730,341556,758527,205941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000746s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]