SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331890 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331890 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507075,307360,565788,347579,911035,268683,222258,746932,422343,1019689,379665,728486,758933,85690,821839,410412,525353,841119,234732,762417,829788,714770,328218,573128,962151,450516,980615,313830,615305,993218,381573,745982,63444,711477,931102,411260,213190,92939,505947,847811,319779,172293,529851,216029,647587,501948,684579,780117,991939,718077,507340,304004,263893,463292,460708,749947,1020404,337080,808124,535047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]