SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265653 LIMIT 1 [ RunTime:0.000837s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265653 [ RunTime:0.002308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759391,645702,373674,4798,995589,985013,434771,654887,626654,195875,22245,454843,335839,161323,866648,1048745,777194,764074,356534,505569,71776,834001,803102,1038790,156557,815469,608158,98715,532233,149271,74340,790151,216698,204202,553903,391993,6411,254512,966767,867395,603619,479916,993288,954729,116453,1011129,112901,244600,1024382,205985,791133,940662,654389,64343,1044400,736056,483214,355623,913920,1024321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000911s ]