SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549028 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549028 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701612,291860,982760,209636,273430,192789,167700,791321,203344,320534,544666,877935,459985,182938,565540,392912,261630,195278,35945,891528,741491,932151,926795,755384,1034313,365126,344825,981224,746680,86402,449631,250897,789564,729724,300218,887213,660154,886616,949388,816474,812527,727942,248344,234836,38601,164581,201015,376807,829626,219167,698254,304602,373477,1012964,145801,218467,1048693,691997,160213,99921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]