SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291643 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291643 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721244,72977,929841,788799,434942,1035396,549304,36843,838376,72809,536510,143324,739015,705073,933348,321277,862387,338224,329841,169332,137491,59186,690429,39976,700226,384941,459383,146209,438232,66696,359197,814363,815793,477056,777486,663650,678414,107960,493854,353475,57639,86187,646965,739602,254611,958362,277785,437882,798902,735760,157669,881501,476797,31275,533333,424197,825174,280286,233119,584655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]