SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439061 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439061 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309413,646848,90243,120006,770756,318538,927283,502591,488378,872004,695598,64501,580808,158429,584799,105545,762320,974190,89459,775683,361627,603896,102557,1030828,938171,246527,666905,673820,692617,468568,92841,863131,704839,222599,925616,581126,922688,715775,107790,30782,80160,414050,641526,225679,781082,103111,923320,682695,949775,774783,933269,985849,638017,410848,876250,749024,627769,774090,1002022,326119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]