SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43817 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43817 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698920,945981,101436,838061,249356,122823,822266,859525,120680,1005007,448987,598724,472250,401517,873517,628442,156391,920993,435209,778776,866728,746266,511324,984816,85638,614916,538232,748237,57883,575021,465166,202440,560319,160373,547654,1045347,91553,366384,450133,1020594,859344,538403,593056,992116,389951,828560,302001,312844,171781,860552,207621,954278,494366,224574,88844,622595,228866,992946,678198,872566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]