SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112452 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112452 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901473,273456,753876,283338,389041,297324,325160,978377,816847,717933,1029378,389807,274939,935493,136249,522579,110264,878451,877421,3504,751721,569204,651166,564089,211571,229615,542194,327018,945637,546091,833220,707786,778928,199189,117990,176166,1418,151823,234682,196862,950407,118095,764594,19559,218541,844912,297385,725316,155742,598646,844613,290792,628801,553327,288373,766708,403611,677286,64137,730823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112452 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112452 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001867s ]