SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809592 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809592 [ RunTime:0.002764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442519,331332,23638,745478,1028466,1009554,1006758,733904,621028,791276,309662,397998,861626,878523,729322,2847,554089,631438,404270,714608,39499,712233,29065,472954,609381,236867,852406,801089,1039846,1017342,428753,1000733,581373,369645,1025337,738637,417410,502758,482732,175667,19007,272363,669999,531104,535260,997920,655281,1013945,321016,387164,735008,934548,759756,106722,1046922,964103,390158,662223,576082,3221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]