SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481964 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481964 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222185,132618,445074,467564,1042305,1021320,237561,714559,909832,690940,22607,174822,1004420,931446,388414,869349,210255,315960,882516,86410,48781,653129,80890,22020,486702,17470,930049,343995,888013,811585,306836,141246,768915,675357,203425,491536,31813,464545,165334,892191,867115,971375,100870,729521,984564,109378,111220,243011,420125,85968,423050,206700,543575,994063,367373,379619,808357,939531,569426,456894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]