SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445884 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445884 [ RunTime:0.002282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439037,504068,128783,971914,956104,15490,1036269,829803,623826,45108,420285,699603,1024905,45344,30882,179091,553796,775781,12840,526622,753526,869760,97681,829204,919280,744102,7527,466413,360638,102384,119042,824837,719720,617038,573065,486177,544037,122861,495361,443010,283249,387377,713741,324017,292292,247862,902892,645296,62705,311799,1019440,290474,615078,845585,428922,1041150,840579,500607,812257,611568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]