SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001122 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001122 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31556,430561,160823,74542,879676,1007136,424198,206311,273989,846966,742028,499134,939666,997846,89845,246886,133246,1045447,662284,748715,56322,663740,1032880,427960,835511,19983,40076,570970,1007079,414914,1042990,327440,175212,600118,210922,973286,416248,569529,484374,477383,108204,198758,218501,945634,990995,1022077,775666,67968,488557,242390,13254,689083,933047,924032,112985,496084,777723,514584,867887,471403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]