SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242418 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242418 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818043,100294,905206,669710,745313,805387,252359,319384,318899,536541,933054,102406,857996,490265,477410,924407,717607,121086,49232,778675,33192,339661,328249,922466,138375,73670,700338,747403,121451,857631,841765,975397,215783,512066,525991,69030,944947,697422,564036,519167,725332,234273,475893,567372,840921,497172,498399,929019,427343,288789,868131,33773,929106,701402,170445,1023473,897975,498689,38931,202548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]