SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561458 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561458 [ RunTime:0.002207s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209649,275148,827015,325008,646305,1015553,342805,1039659,1024870,1036169,820795,872983,406808,272711,776105,987679,305551,415694,402814,1018080,459649,637725,482106,333244,192882,633088,642694,308914,980243,197533,657005,442901,819091,385404,353707,631730,493472,80880,201028,594853,997142,116783,980933,75773,769500,486309,729095,835284,489722,406316,56438,971776,843690,349588,197856,828978,583444,569694,580538,902968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]