SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201662 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201662 [ RunTime:0.003154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85109,122039,588572,659318,1016869,320857,318147,645998,9433,569332,174087,951056,326685,715012,1039192,752280,647145,911553,685891,871898,579469,385645,532533,742090,788468,523910,241137,1025450,26899,292083,230386,93755,680479,264763,836799,9080,1025182,1039718,1020394,388075,1000088,205171,119107,729043,699892,305321,287551,302135,607785,775818,200605,505251,903209,489306,497037,769132,612134,552056,781439,341163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201662 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201662 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]