SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569080 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569080 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044311,811345,438087,666105,271777,370169,127896,328089,508013,1009218,429126,876812,275573,689381,140804,541585,231118,984602,556725,444359,751834,118895,639771,409869,289244,694826,699776,724778,305985,44811,499796,988117,8460,37779,1006009,523433,925006,151792,850529,43888,85624,87728,246499,112014,378102,777944,816936,320784,557872,849492,978126,534809,185653,551944,409574,47560,306327,6548,694753,183428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]