SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442081 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442081 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369373,532535,33415,492851,554150,979259,142797,398370,758915,900579,120488,282467,467381,849851,45181,492343,939229,287009,928522,534137,296032,1039706,998004,702118,282101,39678,486225,768080,843144,1048200,343186,124219,333262,618669,124976,266669,870384,508867,566698,131110,507018,365952,430226,546106,932223,604954,212244,185277,568312,384247,572642,744867,255875,232792,606540,363691,75787,270395,739147,320038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]