SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557896 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557896 [ RunTime:0.001372s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113037,662981,600418,598591,249160,761967,46985,881585,324528,206583,267558,988988,767631,567339,470770,623904,886082,86715,632611,939551,686811,530198,377448,833451,573816,533824,733998,687788,51164,89885,993793,767733,632817,817363,197758,170,284775,178714,266188,715803,499388,339129,229145,953929,858380,625218,714976,392983,112381,908550,8365,871657,311290,195227,645068,314044,815292,1039378,33264,934483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001310s ]