SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020614 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020614 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698110,984166,17239,1812,75255,667136,667433,535047,708132,644957,340385,146997,613378,719960,25246,627108,997794,263758,626970,221697,954751,579456,671972,455356,469079,574288,245812,944200,15027,338174,330590,929294,444563,270345,777475,723660,743013,123282,40949,505444,199615,938051,572504,912188,703413,219674,727252,58552,199706,960623,385555,825247,577362,564941,411679,102076,907091,391692,307000,677366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000786s ]