SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109343 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109343 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831431,84740,48392,814069,748796,785906,915193,606443,461826,406979,62474,514406,752388,859926,392701,635644,425264,847446,613637,345079,547011,378076,883377,121530,678431,561310,193237,265901,499570,56119,886080,814194,958929,783821,557590,553318,127840,512189,743436,786801,668495,478522,214395,975615,1030312,414554,619133,503196,187587,53451,438217,442762,836212,948708,484976,408920,679436,65857,528787,815610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001251s ]