SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038141 LIMIT 1 [ RunTime:0.000590s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038141 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350256,584462,339611,654571,756685,119345,76252,916305,701024,85202,897880,617194,543924,215040,858990,833178,721370,201547,87001,743510,497014,107668,456831,601528,530928,535821,397854,639914,431399,407630,818094,219408,807323,525551,27406,766114,750238,489358,477146,1013888,56070,915506,87894,51992,753267,498935,1008126,777647,655629,418469,229613,81782,773246,127403,806480,709481,785356,639975,1036537,308182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]