SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017308 LIMIT 1 [ RunTime:0.001323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017308 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440801,777586,938821,751968,143940,203103,273639,634409,913184,710702,838555,544808,385376,568482,752505,61279,57180,224193,402686,732839,567419,459706,872267,459661,621243,427896,527786,442801,125235,149438,995717,690557,757760,1011465,263333,848697,982775,872966,53801,132471,818647,613205,988239,159470,631800,1018885,287847,766765,717312,937400,320943,755519,661970,594963,234332,765367,130406,108547,914053,105826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]