SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048102 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048102 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520108,693456,464440,623497,665686,343828,496641,325245,489489,476286,690251,650979,146306,901123,155212,370056,38850,916494,758733,885585,609636,269465,741700,893852,460862,714920,142027,183910,518981,1035519,780156,854588,286827,71762,488621,445794,811680,308913,624578,596053,759970,126420,175803,122558,1028507,414329,759243,918359,693120,497136,655056,155361,381980,790003,73908,770960,899086,510675,684612,1011776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]