SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335109 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335109 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417126,541910,553560,372299,241282,325231,492845,239893,619888,512084,746386,188844,857552,604913,685686,631863,491354,543100,150984,828282,938479,546754,981939,979517,495234,625695,110915,907960,184965,958478,251363,634699,358857,984767,725543,724761,597039,3155,531345,160208,479010,450249,814705,808477,21593,724527,628538,170494,136176,711986,782398,280445,929182,476682,369748,781440,993112,653988,125398,968087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]