SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398914 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398914 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391145,776661,808422,744220,784554,212141,912895,723620,666682,709399,121189,346748,18239,423982,656538,119719,288401,478407,24054,757641,394724,501204,15682,222238,561617,247922,678772,144335,438765,49036,351363,1005389,484079,393776,669246,313820,149063,182403,165533,378059,24816,429408,346737,779331,1000224,502294,898343,117591,461005,735063,860493,824833,643263,681026,999412,85931,157181,644037,319611,106343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]