SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519806 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519806 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470253,759639,366660,897038,695655,316805,584047,993859,1011869,265373,551155,388814,297174,179703,977182,158895,90208,606260,116236,217544,360172,414310,554988,723235,134445,525081,567441,777280,384931,375697,717475,764668,380132,541764,347738,589573,720674,644690,113847,797507,6827,304804,475979,97226,61899,39375,1043116,66970,936242,353718,77019,407697,494323,551162,996620,11303,202295,312552,359127,346286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]