SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348804 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348804 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28375,776329,83391,855049,143631,357091,322104,511937,315164,148017,425924,1014483,994786,540923,541055,231857,1036778,221230,612185,1035525,418066,307710,620009,158259,786578,1002649,205337,261807,856981,1400,821487,639325,465233,599788,426080,121348,771889,496104,671708,49434,757869,618133,405930,879431,47422,772525,930480,751328,359466,784720,672690,240080,445151,440230,280708,674971,1479,408960,150541,706019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]